SELECT parameter, value FROM parameters

SELECT * FROM `bad_bots`

SET time_zone = 'Europe/London'

SELECT version FROM version ORDER BY `installed` DESC LIMIT 1

INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.99\";}'

INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1758071350'

SELECT * FROM autorun ORDER BY lastrun ASC

UPDATE autorun SET lastrun = '2025-09-17 01:09:10' WHERE id = '16'

SELECT * FROM version ORDER BY installed DESC LIMIT 1

SELECT id FROM pages WHERE pagename = 'search' LIMIT 1

SELECT * FROM pages WHERE id = 52

SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'

SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'

SELECT * FROM pages WHERE pagename = 'search'

SELECT * FROM categorygroups ORDER BY sortorder ASC

SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC

SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26

SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26

SELECT id FROM categories WHERE parent_id = '26'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 

SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'

SELECT * FROM categorygroups WHERE id = '1'

SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27

SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27

SELECT id FROM categories WHERE parent_id = '27'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 

SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'

SELECT * FROM categorygroups WHERE id = '1'

SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28

SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28

SELECT id FROM categories WHERE parent_id = '28'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 

SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'

SELECT * FROM categorygroups WHERE id = '1'

SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29

SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29

SELECT id FROM categories WHERE parent_id = '29'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 

SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'

SELECT * FROM categorygroups WHERE id = '1'

SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30

SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30

SELECT id FROM categories WHERE parent_id = '30'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 

SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'

SELECT * FROM categorygroups WHERE id = '1'

SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31

SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31

SELECT id FROM categories WHERE parent_id = '31'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 

SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'

SELECT * FROM categorygroups WHERE id = '1'

SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC

SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC

SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC

SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC

SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'

SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'

SELECT * FROM pages WHERE core = 1 ORDER BY pagekey

SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.99') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.99') <= INET_ATON(ip_end)

SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'

SELECT * FROM countryredirects WHERE countrycode = 'US'

SELECT * FROM pages WHERE pagename = 'search'

SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 

SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name

SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC

SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 

SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name

SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC

INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'palais des thes the vert genmaicha yama bote metal 130g', NOW(), '216.73.216.99'

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'palais') OR (keyfeatures LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (keyfeatures LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (keyfeatures LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (keyfeatures LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (keyfeatures LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (keyfeatures LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (keyfeatures LIKE '130g') OR (title LIKE '130g'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%palais%') OR (keyfeatures LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (keyfeatures LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (keyfeatures LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (keyfeatures LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (keyfeatures LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (keyfeatures LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (keyfeatures LIKE '%130g%') OR (title LIKE '%130g%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'palais') OR (keyfeatures LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (keyfeatures LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (keyfeatures LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (keyfeatures LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (keyfeatures LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (keyfeatures LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (keyfeatures LIKE '130g') OR (title LIKE '130g'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%palais%') OR (keyfeatures LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (keyfeatures LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (keyfeatures LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (keyfeatures LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (keyfeatures LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (keyfeatures LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (keyfeatures LIKE '%130g%') OR (title LIKE '%130g%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT * FROM products WHERE id = '2624'

SELECT * FROM productimages WHERE product_id = '2624' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2624' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '2624'

SELECT * FROM productcustomimages WHERE product_id = '2624'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2624'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2624'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2624

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2624' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2624' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2624' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2624
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2624'
                AND name = 'ListPriceAmount'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2624'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2624'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2624

SELECT value FROM productattributes WHERE product_id = '2624' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2624'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM products WHERE parent_id = '2624'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4902' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4902' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4902' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 4902
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '4902'
                AND name = 'ListPriceAmount'

SELECT * FROM products WHERE id = '2634'

SELECT * FROM productimages WHERE product_id = '2634' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2634'

SELECT * FROM productcustomimages WHERE product_id = '2634'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2634' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2634' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2634' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2634
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2634'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2634' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2653'

SELECT * FROM productimages WHERE product_id = '2653' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2653' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '2653'

SELECT * FROM productcustomimages WHERE product_id = '2653'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2653'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2653

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2653' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2653' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2653' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2653
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2653'
                AND name = 'ListPriceAmount'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2653'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2653

SELECT value FROM productattributes WHERE product_id = '2653' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE parent_id = '2653'

SELECT * FROM products WHERE id = '3012'

SELECT * FROM productimages WHERE product_id = '3012' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '3012'

SELECT * FROM productcustomimages WHERE product_id = '3012'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3012' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3012' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3012' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 3012
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '3012'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '3012' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2663'

SELECT * FROM productimages WHERE product_id = '2663' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2663' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '2663'

SELECT * FROM productcustomimages WHERE product_id = '2663'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2663'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2663'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2663' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2663
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2663'
                AND name = 'ListPriceAmount'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2663'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2663'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663

SELECT value FROM productattributes WHERE product_id = '2663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2663'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM products WHERE parent_id = '2663'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4887' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4887' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4887' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 4887
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '4887'
                AND name = 'ListPriceAmount'

SELECT * FROM products WHERE id = '2674'

SELECT * FROM productimages WHERE product_id = '2674' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2674'

SELECT * FROM productcustomimages WHERE product_id = '2674'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2674' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2674' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2674' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2674
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2674'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2688'

SELECT * FROM productimages WHERE product_id = '2688' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2688'

SELECT * FROM productcustomimages WHERE product_id = '2688'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2688' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2688' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2688' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2688
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2688'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2688' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2690'

SELECT * FROM productimages WHERE product_id = '2690' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2690'

SELECT * FROM productcustomimages WHERE product_id = '2690'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2690' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2690' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2690' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2690
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2690'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2690' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2694'

SELECT * FROM productimages WHERE product_id = '2694' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2694'

SELECT * FROM productcustomimages WHERE product_id = '2694'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2694' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2694' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2694' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2694
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2694'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2694' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2695'

SELECT * FROM productimages WHERE product_id = '2695' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2695'

SELECT * FROM productcustomimages WHERE product_id = '2695'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2695' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2695' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2695' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2695
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2695'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2695' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2697'

SELECT * FROM productimages WHERE product_id = '2697' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2697' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '2697'

SELECT * FROM productcustomimages WHERE product_id = '2697'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2697'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2697'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2697

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2697' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2697' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2697' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2697
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2697'
                AND name = 'ListPriceAmount'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2697'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2697'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2697

SELECT value FROM productattributes WHERE product_id = '2697' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2697'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM products WHERE parent_id = '2697'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1455' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1455' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1455' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 1455
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '1455'
                AND name = 'ListPriceAmount'

SELECT * FROM products WHERE id = '2699'

SELECT * FROM productimages WHERE product_id = '2699' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2699'

SELECT * FROM productcustomimages WHERE product_id = '2699'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2699' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2699' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2699' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2699
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2699'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2699' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2916'

SELECT * FROM productimages WHERE product_id = '2916' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2916'

SELECT * FROM productcustomimages WHERE product_id = '2916'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2916' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2916' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2916' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2916
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2916'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2708'

SELECT * FROM productimages WHERE product_id = '2708' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2708'

SELECT * FROM productcustomimages WHERE product_id = '2708'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2708' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2708' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2708' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2708
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2708'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2708' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2709'

SELECT * FROM productimages WHERE product_id = '2709' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2709'

SELECT * FROM productcustomimages WHERE product_id = '2709'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2709' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2709' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2709' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2709
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2709'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2709' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2711'

SELECT * FROM productimages WHERE product_id = '2711' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2711'

SELECT * FROM productcustomimages WHERE product_id = '2711'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2711' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2711' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2711' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2711
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2711'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2711' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2710'

SELECT * FROM productimages WHERE product_id = '2710' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2710'

SELECT * FROM productcustomimages WHERE product_id = '2710'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2710' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2710' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2710' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2710
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2710'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2710' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2714'

SELECT * FROM productimages WHERE product_id = '2714' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2714'

SELECT * FROM productcustomimages WHERE product_id = '2714'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2714' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2714' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2714' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2714
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2714'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2714' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2624' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2634' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2653' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3012' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2663' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2674' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2688' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2690' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2694' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2695' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2697' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2699' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2916' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2708' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2709' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2711' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2710' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2714' ORDER BY timestamp DESC

SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'

SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'

SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'

SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6

SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6

SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6

SELECT * FROM products WHERE id = 1626

SELECT * FROM products WHERE id = 4041

SELECT * FROM products WHERE id = 4312

SELECT * FROM products WHERE id = 777

SELECT * FROM products WHERE id = 3881

SELECT * FROM products WHERE id = 4213

SELECT * FROM products WHERE id = '1626'

SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1626'

SELECT * FROM productcustomimages WHERE product_id = '1626'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4041'

SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4041'

SELECT * FROM productcustomimages WHERE product_id = '4041'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4312'

SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4312'

SELECT * FROM productcustomimages WHERE product_id = '4312'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '777'

SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '777'

SELECT * FROM productcustomimages WHERE product_id = '777'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '3881'

SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '3881'

SELECT * FROM productcustomimages WHERE product_id = '3881'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4213'

SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4213'

SELECT * FROM productcustomimages WHERE product_id = '4213'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC

SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC

SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''

SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'

SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'

SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'

SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'